{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":108,"n_cols":15,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
[null,"Exercício 5.5 - Simulação"]
[]
[]
[null,"P(AvMotor/AvMotor)",null,null,0.17]
[null,"P(AvProg/AvProg)",null,null,0.5,null,null,null,null,null,null,null,"Performance"]
[null,null,null,null,null,null,null,null,null,null,null,"M1","M2","M3","M4"]
[null,"Nº","Tipo",null,"Próxima ","      Custo","Reparação","        Nº Avarias",null,null,"Média ",{"$f":"AVERAGE(L9:L108)","v":37.65},{"$f":"AVERAGE(M9:M108)","v":37},63,22.795000000000002]
[null,"Avaria","Avaria","NPA","Avaria","Avaria","Acumulado","Motor","Programador",null,"D. Padrão",null,null,null,{"$f":"STDEV(O9:O108)","v":4.4574843428403286}]
[null,0,"Motor",{"$f":"RAND()","v":0.48961159201203985},{"$f":"IF(C9=\"Motor\",IF(D9<$E$4,\"Motor\",\"Programador\"),IF(D9<$E$5,\"Programador\",\"Motor\"))","v":"Programador"},0,{"$f":"+F9","v":0},0,0,null,null,{"$f":"+F34","v":50},{"$f":"+F36","v":25},{"$f":"+F38","v":75},{"$f":"+F40","v":18.75}]
[null,{"$f":"+B9+1","v":1},{"$f":"+E9","v":"Programador"},{"$f":"RAND()","v":0.38047125353239841},{"$f":"IF(C10=\"Motor\",IF(D10<$E$4,\"Motor\",\"Programador\"),IF(D10<$E$5,\"Programador\",\"Motor\"))","v":"Programador"},{"$f":"IF(C9=\"Motor\",IF(C10=\"Motor\",0,20),IF(C10=\"Programador\",0,55))","v":20},{"$f":"+G9+F10","v":20},{"$f":"IF(C10=\"Motor\",H9+1,H9)","v":0},{"$f":"IF(C10=\"Motor\",I9,I9+1)","v":1},{"$f":"IF(F10=0,1,0)","v":0},1,15,45,55.000000000000007,31]
[null,{"$f":"+B10+1","v":2},{"$f":"+E10","v":"Programador"},0.96848991488565117,"Motor",{"$f":"IF(C10=\"Motor\",IF(C11=\"Motor\",0,20),IF(C11=\"Programador\",0,55))","v":0},{"$f":"+G10+F11","v":20},{"$f":"IF(C11=\"Motor\",H10+1,H10)","v":0},{"$f":"IF(C11=\"Motor\",I10,I10+1)","v":2},{"$f":"IF(F11=0,1,0)","v":1},{"$f":"+K10+1","v":2},55.000000000000007,40,60,16]
[null,3,"Motor",0.2734662472873578,"Programador",{"$f":"IF(C11=\"Motor\",IF(C12=\"Motor\",0,20),IF(C12=\"Programador\",0,55))","v":55},75,1,2,0,{"$f":"+K11+1","v":3},20,45,55.000000000000007,30]
[null,4,"Programador",0.14998342077221594,"Programador",20,95,1,3,0,4,40,40,60,22.5]
[null,5,"Programador",0.65093822228703935,"Motor",0,95,1,4,1,5,65,30,70,12.25]
[null,6,"Motor",0.19124817307530562,"Programador",55,150,2,4,0,6,45,40,60,19.75]
[null,7,"Programador",4.9649760726506176E-2,"Programador",20,170,2,5,0,7,55.000000000000007,25,75,16]
[null,8,"Programador",0.13063876300983857,"Programador",0,170,2,6,1,8,35,30,70,23.5]
[null,9,"Programador",0.6803833216576135,"Motor",0,170,2,7,1,9,45,25,75,19.75]
[null,10,"Motor",0.26477168706422238,"Programador",55,225,3,7,0,10,55.000000000000007,30,70,16]
[null,11,"Programador",0.39992549811370182,"Programador",20,245,3,8,0,11,65,15,85,12.25]
[null,12,"Programador",0.38608587145470075,"Programador",0,245,3,9,1,12,50,40,60,18.75]
[null,13,"Programador",0.46252927489600415,"Programador",0,245,3,10,1,13,25,35,65,27.25]
[null,14,"Programador",0.19788362783120561,"Programador",0,245,3,11,1,14,45,30,70,19.75]
[null,15,"Programador",0.2252867308118166,"Programador",0,245,3,12,1,15,35,35,65,23.5]
[null,{"$f":"+B24+1","v":16},{"$f":"+E24","v":"Programador"},0.69403237095159598,{"$f":"IF(C25=\"Motor\",IF(D25<$E$4,\"Motor\",\"Programador\"),IF(D25<$E$5,\"Programador\",\"Motor\"))","v":"Motor"},{"$f":"IF(C24=\"Motor\",IF(C25=\"Motor\",0,20),IF(C25=\"Programador\",0,55))","v":0},245,{"$f":"IF(C25=\"Motor\",H24+1,H24)","v":3},{"$f":"IF(C25=\"Motor\",I24,I24+1)","v":13},1,16,35,45,55.000000000000007,23.5]
[null,{"$f":"+B25+1","v":17},{"$f":"+E25","v":"Motor"},0.23484090818718439,{"$f":"IF(C26=\"Motor\",IF(D26<$E$4,\"Motor\",\"Programador\"),IF(D26<$E$5,\"Programador\",\"Motor\"))","v":"Programador"},{"$f":"IF(C25=\"Motor\",IF(C26=\"Motor\",0,20),IF(C26=\"Programador\",0,55))","v":55},300,{"$f":"IF(C26=\"Motor\",H25+1,H25)","v":4},{"$f":"IF(C26=\"Motor\",I25,I25+1)","v":13},0,17,30,40,60,26.25]
[null,{"$f":"+B26+1","v":18},{"$f":"+E26","v":"Programador"},0.40070776299871702,{"$f":"IF(C27=\"Motor\",IF(D27<$E$4,\"Motor\",\"Programador\"),IF(D27<$E$5,\"Programador\",\"Motor\"))","v":"Programador"},{"$f":"IF(C26=\"Motor\",IF(C27=\"Motor\",0,20),IF(C27=\"Programador\",0,55))","v":20},320,{"$f":"IF(C27=\"Motor\",H26+1,H26)","v":4},{"$f":"IF(C27=\"Motor\",I26,I26+1)","v":14},0,18,30,40,60,26.25]
[null,{"$f":"+B27+1","v":19},{"$f":"+E27","v":"Programador"},0.8441273545859721,{"$f":"IF(C28=\"Motor\",IF(D28<$E$4,\"Motor\",\"Programador\"),IF(D28<$E$5,\"Programador\",\"Motor\"))","v":"Motor"},{"$f":"IF(C27=\"Motor\",IF(C28=\"Motor\",0,20),IF(C28=\"Programador\",0,55))","v":0},320,{"$f":"IF(C28=\"Motor\",H27+1,H27)","v":4},{"$f":"IF(C28=\"Motor\",I27,I27+1)","v":15},1,19,40,45,55.000000000000007,22.5]
[null,{"$f":"+B28+1","v":20},{"$f":"+E28","v":"Motor"},0.42383887126027464,{"$f":"IF(C29=\"Motor\",IF(D29<$E$4,\"Motor\",\"Programador\"),IF(D29<$E$5,\"Programador\",\"Motor\"))","v":"Programador"},{"$f":"IF(C28=\"Motor\",IF(C29=\"Motor\",0,20),IF(C29=\"Programador\",0,55))","v":55},375,{"$f":"IF(C29=\"Motor\",H28+1,H28)","v":5},{"$f":"IF(C29=\"Motor\",I28,I28+1)","v":15},0,20,30,45,55.000000000000007,26.25]
[null,null,null,null,null,null,null,null,null,null,21,45,40,60,19.75]
[null,null,null,null,null,null,null,null,null,null,22,35,30,70,23.5]
[null,null,null,"Medidas de Performance",null,null,null,null,null,null,23,15,50,50,31]
[null,null,null,null,null,null,null,null,null,null,24,35,40,60,23.5]
[null,"M1","% Reparações gratuitas",null,null,{"$f":"SUM(J10:J29)/MAX(B9:B29)*100","v":50},"%",null,null,null,25,10,45,55.000000000000007,33.75]
[null,null,null,null,null,null,null,null,null,null,26,45,25,75,19.75]
[null,"M2","% Avarias no Motor",null,null,{"$f":"+MAX(H9:H29)/MAX(B9:B29)*100","v":25},"%",null,null,null,27,45,35,65,19.75]
[null,null,null,null,null,null,null,null,null,null,28,15,45,55.000000000000007,31]
[null,"M3","% Avarias no Programador",null,null,{"$f":"MAX(I9:I29)/MAX(B9:B29)*100","v":75},"%",null,null,null,29,55.000000000000007,25,75,16]
[null,null,null,null,null,null,null,null,null,null,30,40,30,70,22.5]
[null,"M4","Custo médio por avaria",null,null,{"$f":"MAX(G9:G29)/MAX(B9:B29)","v":18.75},"u.m.",null,null,null,31,45,30,70,19.75]
[null,null,null,null,null,null,null,null,null,null,32,40,40,60,22.5]
[null,null,null,null,null,null,null,null,null,null,33,25,40,60,27.25]
[null,null,null,null,null,null,null,null,null,null,34,65,25,75,12.25]
[null,null,null,null,null,null,null,null,null,null,35,30,45,55.000000000000007,26.25]
[null,null,null,null,null,null,null,null,null,null,36,45,35,65,19.75]
[null,null,null,null,"     Intervalo de Confiança a ",null,null,0.95,null,null,37,20,45,55.000000000000007,30]
[null,null,null,null,null,"Custos Médio por avaria",null,null,null,null,38,35,55.000000000000007,45,23.5]
[null,null,null,null,null,null,null,null,null,null,39,40,40,60,22.5]
[null,null,null,null,"Limite Inferior",null,null,"Limite Superior",null,null,40,30,45,55.000000000000007,26.25]
[null,null,null,null,{"$f":"+$O$7-$O$8/SQRT(K108+1)*TINV(1-$H$46,$K$108)","v":21.910538400550521},null,null,{"$f":"+$O$7+$O$8/SQRT($K$108+1)*TINV(1-$H$46,$K$108)","v":23.679461599449482},null,null,41,45,30,70,19.75]
[null,null,null,null,null,null,null,null,null,null,42,50,30,70,18.75]
[null,null,null,null,null,null,null,null,null,null,43,30,40,60,26.25]
[null,null,null,null,null,null,null,null,null,null,44,40,30,70,22.5]
[null,null,null,null,null,null,null,null,null,null,45,30,45,55.000000000000007,26.25]
[null,null,null,null,null,null,null,null,null,null,46,25,40,60,27.25]
[null,null,null,null,null,null,null,null,null,null,47,45,30,70,19.75]
[null,null,null,null,null,null,null,null,null,null,48,30,35,65,26.25]
[null,null,null,null,null,null,null,null,null,null,49,30,45,55.000000000000007,26.25]
[null,null,null,null,null,null,null,null,null,null,50,45,35,65,19.75]
[null,null,null,null,null,null,null,null,null,null,51,45,35,65,19.75]
[null,null,null,null,null,null,null,null,null,null,52,35,30,70,23.5]
[null,null,null,null,null,null,null,null,null,null,53,40,35,65,22.5]
[null,null,null,null,null,null,null,null,null,null,54,45,25,75,19.75]
[null,null,null,null,null,null,null,null,null,null,55,15,45,55.000000000000007,31]
[null,null,null,null,null,null,null,null,null,null,56,35,35,65,23.5]
[null,null,null,null,null,null,null,null,null,null,57,45,30,70,19.75]
[null,null,null,null,null,null,null,null,null,null,58,55.000000000000007,35,65,16]
[null,null,null,null,null,null,null,null,null,null,59,25,45,55.000000000000007,27.25]
[null,null,null,null,null,null,null,null,null,null,60,20,45,55.000000000000007,30]
[null,null,null,null,null,null,null,null,null,null,61,25,45,55.000000000000007,27.25]
[null,null,null,null,null,null,null,null,null,null,62,35,45,55.000000000000007,23.5]
[null,null,null,null,null,null,null,null,null,null,63,35,35,65,23.5]
[null,null,null,null,null,null,null,null,null,null,64,35,30,70,23.5]
[null,null,null,null,null,null,null,null,null,null,65,35,35,65,23.5]
[null,null,null,null,null,null,null,null,null,null,66,60,30,70,15]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+K75+1","v":67},40,35,65,22.5]
[null,null,null,null,null,null,null,null,null,null,68,45,25,75,19.75]
[null,null,null,null,null,null,null,null,null,null,69,35,35,65,23.5]
[null,null,null,null,null,null,null,null,null,null,70,35,30,70,23.5]
[null,null,null,null,null,null,null,null,null,null,71,25,45,55.000000000000007,27.25]
[null,null,null,null,null,null,null,null,null,null,72,50,35,65,18.75]
[null,null,null,null,null,null,null,null,null,null,73,35,30,70,23.5]
[null,null,null,null,null,null,null,null,null,null,74,55.000000000000007,40,60,16]
[null,null,null,null,null,null,null,null,null,null,75,30,55.000000000000007,45,26.25]
[null,null,null,null,null,null,null,null,null,null,76,55.000000000000007,30,70,16]
[null,null,null,null,null,null,null,null,null,null,77,35,30,70,23.5]
[null,null,null,null,null,null,null,null,null,null,78,35,30,70,23.5]
[null,null,null,null,null,null,null,null,null,null,79,45,40,60,19.75]
[null,null,null,null,null,null,null,null,null,null,80,15,40,60,31]
[null,null,null,null,null,null,null,null,null,null,81,40,30,70,22.5]
[null,null,null,null,null,null,null,null,null,null,82,50,35,65,18.75]
[null,null,null,null,null,null,null,null,null,null,83,25,40,60,27.25]
[null,null,null,null,null,null,null,null,null,null,84,35,35,65,23.5]
[null,null,null,null,null,null,null,null,null,null,85,35,35,65,23.5]
[null,null,null,null,null,null,null,null,null,null,86,25,50,50,27.25]
[null,null,null,null,null,null,null,null,null,null,87,35,35,65,23.5]
[null,null,null,null,null,null,null,null,null,null,88,35,35,65,23.5]
[null,null,null,null,null,null,null,null,null,null,89,40,35,65,22.5]
[null,null,null,null,null,null,null,null,null,null,90,25,40,60,27.25]
[null,null,null,null,null,null,null,null,null,null,91,45,50,50,19.75]
[null,null,null,null,null,null,null,null,null,null,92,35,45,55.000000000000007,23.5]
[null,null,null,null,null,null,null,null,null,null,93,55.000000000000007,35,65,16]
[null,null,null,null,null,null,null,null,null,null,94,35,35,65,23.5]
[null,null,null,null,null,null,null,null,null,null,95,25,45,55.000000000000007,27.25]
[null,null,null,null,null,null,null,null,null,null,96,45,45,55.000000000000007,19.75]
[null,null,null,null,null,null,null,null,null,null,97,40,40,60,22.5]
[null,null,null,null,null,null,null,null,null,null,98,40,35,65,22.5]
[null,null,null,null,null,null,null,null,null,null,99,30,50,50,26.25]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}